﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Visual/Template/formulario.master" AutoEventWireup="true" CodeFile="SequencesReport.aspx.cs" Inherits="Visual_Procedures_Reports_SequencesReport" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
 <link href="../../../Styles/interfacemetro/css/modern-responsive.css" rel="stylesheet"type="text/css" />
    <link href="../../../Styles/interfacemetro/css/modern.css" rel="stylesheet" type="text/css" />
    <link href="../../../Styles/menustyles.css" rel="stylesheet" type="text/css" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="botoes" Runat="Server">
 <br /><br /><br /><br /><br /><br /><br /><div style="margin-left:20px;"><h2>Select an Organism</h2>
 <div class="input-control select">
 <asp:DropDownList ID="ddOrganism" runat="server" 
        AutoPostBack="True" onselectedindexchanged="ddOrganism_SelectedIndexChanged" Width="400px">
    </asp:DropDownList>
    </div></div>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="header" Runat="Server">
<h1>Sequences Report</h1>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ConteudoDinamico" Runat="Server">

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:vsdbmConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:vsdbmConnectionString.ProviderName %>" 
        SelectCommand="SELECT     sequences.id, sequences.idacession, sequences.idorganism, sequences.locus, sequences.definition, sequences.idpubmed, sequences.sequence, 
                      sequences.iduser_register, sequences.size, sequences.status, organisms.name AS OrganismName, users.name AS UserName
FROM         sequences INNER JOIN
                      organisms ON sequences.idorganism = organisms.id INNER JOIN
                      users ON sequences.iduser_register = users.id
WHERE     (sequences.idorganism = 0)">
    </asp:SqlDataSource>
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="750px" 
        ZoomPercent="90">
        <localreport reportpath="App_Code\reports\SequencesReport.rdlc">
            <datasources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="SequenceDataSet" />
            </datasources>
        </localreport>
    </rsweb:ReportViewer>
</asp:Content>

